SELECT EXTRACTVALUE( de.family_doctor, 'rd' ) AS ReferredBy, EXTRACTVALUE( de.family_doctor, 'rdohip' ) AS LicNo, de.last_name, de.first_name, date_joined AS DateJoined, CONCAT( "" , de.demographic_no, "" ) As Link FROM demographic de WHERE LENGTH( EXTRACTVALUE( de.family_doctor, 'rd' )) > 1 AND LOCATE('{referredby}', EXTRACTVALUE( de.family_doctor, 'rd' ) ) > 0 AND date_joined BETWEEN '{start}' AND '{finish}' ORDER BY EXTRACTVALUE( de.family_doctor, 'rd' ) ;